package com.example.component.d_content_provider.custom

import android.content.Context
import android.database.sqlite.SQLiteDatabase
import android.database.sqlite.SQLiteOpenHelper
import android.widget.Toast

class MyDatabaseHelper(val context: Context, name: String, version: Int) :
    SQLiteOpenHelper(context, name, null, version) {

    private val createBook =
        """create table Book (
            id integer primary key autoincrement,
            author text,
            price real,
            pages integer,
            name text)"""

    private val createCategory =
        """create table Category (
            id integer primary key autoincrement,
            category_name text,
            category_code integer)"""

    override fun onCreate(db: SQLiteDatabase) {
        db.execSQL(createBook)
        db.execSQL(createCategory)
        Toast.makeText(context, "Create succeeded", Toast.LENGTH_SHORT).show()
    }

    override fun onUpgrade(db: SQLiteDatabase, oldVersion: Int, newVersion: Int) {
        /**
         * 数据库版本升级，
         * 版本为 1 时，仅有 Book 表，
         * 版本为 2 时，同时有 Book 和 Category 表
         */
        if (oldVersion <= 1) {
            db.execSQL(createCategory)
        }
    }
}